How to: Select a record or records in a Table Datasheet.
Solution:
Open the Table Datasheet view, and click on the 'Row Selector' for the record to select.
1) If the Database window is not active, activate the Database window.
2) Open the Table Datasheet view.
3) Click on the 'Row Selector' for the desired record to select.
Row Selector
NOTE 1: To select multiple adjacent records, press and hold down SHIFT while selecting the 'Row Selector' for each record.
NOTE 2: To select multiple non-adjacent records, press and hold down CTRL while selecting the 'Row Selector' for each record.
4) Perform the desired action(s) on the selected record(s).
5) (Optional) Select the 'File' menu and select 'Save' to save changes.
6) (Optional) Select the 'File' menu and select 'Close' to close the Table Datasheet view. (The Table Datasheet view closes, and changes are saved automatically if not already saved.)